if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sp_KhuVuc_Update]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sp_KhuVuc_Update]
GO
CREATE PROC [sp_KhuVuc_Update]
	@id						int,
	@Ten					nvarchar(50),
	@Ghi_chu				nvarchar(100)

AS
BEGIN
	DECLARE @Ngay_cap_nhat_cuoi datetime
	SET @Ngay_cap_nhat_cuoi = getdate()
	Update KhuVuc
		SET
				Ten = @Ten,
				Ghi_chu = @Ghi_chu,
				Ngay_cap_nhat_cuoi = @Ngay_cap_nhat_cuoi
		WHERE ID = @id
END
